package com.woniuxy.his.mapper;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.woniuxy.his.entity.Doctor;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.woniuxy.his.vo.ArrangeVo;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 * 医生表 Mapper 接口
 * </p>
 *
 * @author Lucas
 * @since 2021-08-25
 */
public interface DoctorMapper extends BaseMapper<Doctor> {

    @Select("select * from his_doctor where doctor_id in (select doctor_id from his_arrange where arrange_time=#{arrangeTime})")
    IPage<Doctor> findDoctorsByArrangeTime(IPage<Doctor> page, String arrangeTime);



}
